package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.pojo.Emp;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

@Mapper
public interface EmpMapper  extends BaseMapper<Emp> {
//    @Select("select count(*) from emp e  ")
//    public Long count ();

    //    @Select("select e.*, d.name deptName from emp  e left join dept  d on e.dept_id = d.id" +
//            "where e.name like concat('%',#{name},'%') and e.gender=#{gender} and e.entry_date between #{begin} and #{end}")
//    public List<Emp> list ( EmpQueryParam empQueryParam );
//
//    //    @Insert("insert into emp(username, name, gender, phone, job, salary, image, entry_date, dept_id, create_time, update_time) " +
////            "values (#{username},#{name},#{gender},#{phone},#{job},#{salary},#{image},#{entryDate},#{deptId},#{createTime},#{updateTime})")
//    void save ( Emp emp );
//
//    void deleteByIds ( List<Integer> ids );
//
//    @Select("select * from emp where id =#{id}")
//    Emp getById ( Integer id );
//
//    void updateById ( Emp emp );
//
//
   List<Map> countEmpJobData ();
//
    List<Map> countEmpGenderData ();
//
//    @Select("select * from emp")
//    List<Emp> findAllEmp ();
//
    int selectCountByDeptId ( Integer deptId );


}